SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589534 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589534 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (900854,800161,1005874,668352,839683,808837,492901,37988,539723,431540,725800,210220,340480,535499,471202,759562,160103,985295,843943,312333,201789,359390,966701,907288,116047,131389,112997,999433,901843,993441,965971,910866,449874,504880,347866,804188,572352,667444,106178,403271,965421,742521,477111,332454,997757,664222,441428,880962,602474,273560,955230,672748,49433,87097,312863,470152,666046,583459,781908,1028919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]