SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544343 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544343 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191578,884659,259213,819688,819504,17807,490769,324106,1835,72105,658844,1037511,1027219,605097,861871,968953,81449,86000,494565,241816,393322,788436,280631,467749,968454,159959,73383,606909,1004519,541558,807390,570074,268339,956434,437211,582437,365749,336317,306792,892633,699723,735422,116315,248023,41145,498859,424200,172705,515851,283444,259869,110903,965555,9266,1037756,508917,1017465,105892,689563,719756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]