SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045971 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045971 [ RunTime:0.006519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756662,444516,326167,877433,79577,140879,521829,90886,813083,743112,143510,108090,808924,505362,565144,310161,202143,431494,421904,96489,551351,297127,450392,630246,914972,125932,84305,756040,563171,1021443,550018,464284,385068,630049,968090,560899,487620,538035,322926,846421,29259,481635,432902,639797,274025,669143,137061,197428,360856,1016988,662382,388875,884699,871691,918362,802628,186725,279757,260303,645643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]