SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 350048 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 350048 [ RunTime:0.003809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440088,156837,685798,741577,167354,17693,588490,608626,379163,490103,513521,832142,760997,314490,325913,565554,448364,612116,994838,79255,300157,1037757,420346,708920,85801,671223,1023751,189043,36478,438566,180106,396532,45046,786584,334480,172037,87311,616599,75080,577661,870539,33697,455812,765161,139236,292269,632456,66815,689583,958709,105019,52330,493759,770689,119173,103415,420370,437200,1008095,259871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 350048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 350048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]