SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407113 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407113 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881349,339886,482678,874577,669149,107764,861784,809504,911154,254432,245686,853431,602792,1048045,759452,616666,678667,251893,495079,824746,717897,764143,678573,709079,933155,179311,411714,6221,431794,564008,186482,907822,609988,520173,54509,552821,1002416,771181,929405,788155,795097,369518,334782,148738,502921,246119,947723,9757,1019824,640936,544113,745691,877418,1034748,476410,1027447,897583,395684,989990,323440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]