SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001961s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046425 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046425 [ RunTime:0.001361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186381,223088,440881,381543,185131,124069,1011987,424221,783336,259224,1025612,594565,630246,790331,810622,276475,996959,148472,396498,702294,789940,687218,3167,49739,94684,197652,305562,892546,776901,71577,98503,144965,519827,844538,97814,1026493,381476,863169,73844,279011,158016,465400,541327,492023,201242,469624,457579,29978,345146,398994,617913,739611,473381,911362,116310,716514,992794,14141,396999,915134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]