SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44535 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44535 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530575,1014868,29980,791233,202917,803074,873671,666471,946286,696535,513056,616947,114611,199529,568702,844306,766930,822161,966520,238510,664072,629518,428171,155075,492715,370506,958137,217228,486571,716588,149800,601788,702878,75558,518147,172204,741301,146609,500555,781068,15107,862993,359137,126900,1021895,751962,813251,657291,871941,24170,334686,492168,58991,404143,355538,1033040,407694,382017,397889,204167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]