SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314967 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314967 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026669,627992,523734,472865,975104,705821,116849,827776,1036813,399783,34146,550692,220166,87842,297513,163597,651676,589753,926797,681347,106941,179244,236528,90630,331771,271557,49592,1000903,251550,716529,706140,794569,29769,1038461,624430,526827,485290,128825,786096,215188,111896,179641,557939,931219,821273,732070,212395,242973,902324,1020051,915420,729572,280021,853040,402627,813029,809186,913231,927480,198655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001723s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]