SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495843 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495843 [ RunTime:0.002320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225314,72448,500603,794475,326060,325538,645661,194660,892023,424005,1014664,480055,794921,1030000,605879,269470,252225,146743,77651,341109,636945,269997,328051,92097,311230,24269,467318,392846,343928,297319,636601,177998,468460,828564,619372,347005,746726,777419,1014864,187373,368518,344238,335675,820251,262124,646926,440851,680397,391263,803626,990810,66131,580688,465510,174905,867401,438861,690909,1048446,847015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000961s ]