SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034138 LIMIT 1 [ RunTime:0.000995s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034138 [ RunTime:0.002546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438829,780888,967540,623364,516988,733070,806895,222197,321103,655074,275843,501882,770620,1043651,396665,371462,525861,558800,1032542,12356,303996,388537,747351,897464,253026,350756,785725,634946,125110,515578,392253,1004426,229135,1019045,305157,490228,291499,342247,191573,776349,956309,805693,603321,683944,474012,788712,495943,730949,1005169,329077,411576,177318,388169,877759,637458,997529,671213,759787,333284,359856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.031921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004685s ]