SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503381 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503381 [ RunTime:0.003449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498204,941538,800821,792389,743787,140699,755616,297871,587782,920381,582792,247421,642763,151643,599613,7416,741172,455791,876559,904240,645779,299605,641015,77006,863736,286053,162879,748123,874454,1042088,922343,84809,618298,968768,109629,736403,47735,13498,110183,757709,589395,219892,352667,1020568,321140,161406,1002343,657296,554045,577742,267334,52589,168482,579419,83703,1024347,37051,556572,210973,500059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]