SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021678 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021678 [ RunTime:0.003294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993016,866867,574304,758699,194861,260457,809458,823622,895738,511055,759463,543790,4579,608890,553906,641346,919566,1014293,692962,592562,766239,987873,331549,209889,347421,874609,190669,63426,946333,744438,854218,190704,808567,631192,992138,128727,801935,956858,546026,686652,971168,692486,1028421,805226,262663,470848,112828,1043468,939197,266558,608866,12644,82501,647781,448260,78528,668483,694265,487175,321886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]