SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479596 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479596 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89354,272746,3466,881688,296057,139812,991069,183932,93841,281482,553919,592162,909132,458075,173247,519059,763572,616339,329569,442883,543544,1027129,182498,950288,418955,172282,213363,31654,132935,844438,269927,672759,620884,226892,598336,991339,231465,236116,966978,153926,917054,253506,357812,298937,448168,859993,880389,822832,215967,258660,159704,342030,793921,23134,833953,930720,611215,413866,1029240,816512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001527s ]