SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507891 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507891 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978536,320844,296306,392981,331444,178029,241889,877456,400426,512063,92076,206329,923795,812494,357697,850258,565,444092,606374,38275,850512,219370,707004,1044487,418038,123850,175697,111242,391792,805550,83430,595077,653532,853597,123640,75086,194637,878105,180806,751899,806139,213210,829064,120093,760928,563267,341551,366841,277461,296930,418766,222660,1037208,45549,92034,598729,33078,479346,130610,628670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]