SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002609 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002609 [ RunTime:0.001422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309723,128444,712709,755993,1020126,223841,681214,663421,872171,959801,974818,704012,479497,1005562,387287,8588,678646,566964,559363,148437,830209,274288,209920,436196,82258,142593,270416,555883,283226,62659,412467,764913,19351,145707,847004,18277,363495,935488,844424,170600,1036922,1045770,379035,503124,395407,794674,966482,512594,1042421,135161,357444,775875,46927,541126,571098,860994,280347,133454,416675,909529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]