SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014442 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014442 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365888,378217,716888,720563,848122,285147,25311,974320,922479,78253,477799,238792,21212,795908,122800,909533,934472,1024996,548813,591231,382832,521362,992570,231931,543441,791067,302671,464382,471948,837414,222141,530546,85806,949809,1012472,425650,408184,439625,628674,167609,651028,360423,477077,236246,801118,295433,931483,881142,912488,901284,467726,543002,575098,824721,28144,783940,1046722,300835,694528,396494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]