SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508760 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508760 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105472,935267,944594,351654,201346,886359,652300,294491,103560,815143,731021,433583,713503,1016067,960277,6143,778222,295819,746115,161574,356529,906446,856385,247910,267519,149035,353502,762978,748833,880546,267182,799076,685032,541037,497055,221306,472650,581789,570824,122052,623928,405208,449398,362555,1020816,1046846,385418,207766,410328,346038,283790,527694,586055,760878,802965,887114,471529,990184,977380,296360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]