SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555175 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555175 [ RunTime:0.002567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421518,703754,1036353,255880,275266,334527,972115,672393,618970,403940,149945,775343,196146,429913,702312,463598,745038,901633,124194,888238,1015648,698006,798877,565102,119158,1006746,565209,79497,143573,839737,494629,379537,14202,868736,454701,477090,590494,977668,331579,338079,778099,717473,872875,902108,923235,313375,889801,1030059,583937,25439,784795,402470,783338,47030,1021335,523481,907926,594220,408577,1047767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]