SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414617 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414617 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530143,1016905,287850,123491,44872,135019,656299,66950,4125,98946,611729,228157,223951,494486,10200,950346,509007,514727,1042017,54470,653812,543172,709634,773701,353564,444752,901490,741611,531689,908556,396780,934005,1027076,1028488,1044757,337073,148838,44756,365265,487327,748543,910429,909763,296192,749282,522449,220777,784219,757548,111725,26866,177984,291177,873939,636036,713252,226862,160326,853616,360837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]