SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405020 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405020 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281101,695835,931257,807475,1048814,142840,956410,180726,727507,420492,586010,422434,652904,417441,513778,1034455,19369,950780,183190,798850,115568,985297,461532,990144,1017483,593538,957629,454108,932392,670247,333543,95333,257670,763267,678324,653488,194665,146108,1001049,340856,96102,378054,650861,562962,539283,954147,1004535,968396,372378,978898,862351,464808,209932,623858,369729,875352,47166,477484,969924,659848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001501s ]