SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328588 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328588 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043347,437284,536951,105886,988832,936287,696423,430126,1014702,331003,781917,735858,276692,430855,524020,372826,784621,279250,794479,531820,165415,329440,523950,266300,897848,621886,185564,869910,128371,949367,49725,775206,548010,233572,910975,817588,864969,472465,348125,1005673,496720,224771,176293,28317,718641,560067,353528,718473,623443,29218,672675,978445,769787,11751,580818,605224,418321,275665,974809,608413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]