SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36449 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36449 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268058,1033396,126052,681864,562866,984147,475420,204700,881040,917494,473745,1037832,329154,311258,445671,987906,270252,566890,28809,949957,978745,618311,691822,41022,542832,125085,961484,453417,391989,261780,827143,1007069,682684,639019,576816,1009369,571102,204966,616010,866357,248140,435919,11460,654762,546697,210842,759824,978580,469117,701774,228407,590608,486967,272174,877354,751081,712309,127212,929867,402277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]