SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577833 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577833 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484181,661017,893638,848164,339129,872314,257682,246096,967093,117875,83115,111110,458438,470918,622270,259698,1019787,248675,740704,85423,433297,1022689,986652,870677,399257,655367,338778,275331,351390,564178,974343,818078,66212,212841,844945,822372,329379,871944,435852,599412,551941,707199,889357,866809,311875,1020437,840870,667979,559762,140237,624491,104172,412021,209798,1015850,418400,955690,77700,575568,778920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]