SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509810 LIMIT 1 [ RunTime:0.001995s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509810 [ RunTime:0.002799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430689,182183,177626,522336,39763,9037,119267,538466,1034909,629509,231611,1010425,304230,573990,154924,862389,211046,628574,232421,763875,874672,811463,246679,86251,532943,746431,747744,654636,712099,157138,907203,121471,748382,524916,325068,753934,84560,381497,130797,301632,849947,400545,754870,279452,1037863,103872,502867,573854,652729,196514,538049,521725,810119,86736,386421,193093,537944,880191,970971,333307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002004s ]