SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026650 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026650 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501666,153686,357376,754078,188906,158337,190777,260442,328082,854441,572855,485307,193991,979048,259892,52583,1009652,366609,1002935,215229,769791,803188,804689,287527,131235,44872,530765,927039,248510,114531,306622,894735,366199,1020863,1019363,369859,909041,692686,511300,234899,898464,145825,166324,138442,656534,567872,713665,186129,368341,209984,329749,22341,904131,523007,771965,378319,923183,992235,858258,796844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]