SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150648 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150648 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358022,691934,139523,690680,514808,550894,18269,533903,597626,249393,486133,376955,556734,368675,891352,60455,615955,556613,434557,951344,840446,18918,177395,768410,1044757,96683,484095,868119,101142,603566,734778,177170,871214,395149,778020,383178,842521,107700,754090,1025298,214210,807061,747449,1005898,814285,670519,690979,73223,662148,797742,823900,610676,239651,475933,132018,590418,436947,414834,309100,875538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]