SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316043 LIMIT 1 [ RunTime:0.000589s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316043 [ RunTime:0.003082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519641,127997,442238,25455,113288,506446,586026,951220,302324,214356,2396,787636,493578,116109,442495,368755,632709,851611,675397,962274,1026672,118473,775785,570563,312802,441772,218869,623984,5749,498089,612421,338130,726989,487676,727255,301630,503863,1025023,238030,776498,634019,824897,302366,674363,982812,601244,716625,564460,20085,336503,259772,292760,263093,55685,629111,274770,392229,874311,854117,856523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]