SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561097 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561097 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540223,905018,202536,507951,35563,604832,816068,745965,71054,415774,880817,102077,332585,1035859,874655,836576,245247,233622,735089,905965,382484,934765,458837,602500,345686,769413,382691,520961,442449,156535,114059,557966,709095,51037,928611,538588,111945,830634,567965,787246,696775,172336,979700,992777,429565,830811,940925,232388,257496,639672,838339,519196,145929,1035501,814186,103981,257320,54017,434704,943145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003196s ]