SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396908 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396908 [ RunTime:0.005061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031390,1015589,367557,254913,844582,72128,567735,854774,901118,209739,278574,967944,227282,769445,1929,529329,9556,364564,363186,631703,260905,1042588,1045109,673539,413886,316902,984194,310336,11392,983709,932138,961160,962561,422582,460462,469059,576552,539668,21578,842598,943785,763399,481015,428996,838071,639630,93714,971783,816567,870559,559328,314563,854614,440961,1014540,485371,813678,330849,443555,85183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]