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` = 627216 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 627216 [ RunTime:0.002868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017612,786370,517432,584609,296582,1003170,425388,10358,287880,581899,70426,973486,327131,474143,448811,121786,212735,783715,630534,135213,937105,614502,1034479,641475,589566,934141,168200,818425,383561,190829,74341,243617,493940,1003808,284993,838199,700010,524417,695685,1013298,598515,353280,969999,332519,25798,994076,436672,970109,56187,521314,866222,889272,174084,118251,1002778,911797,1011306,510830,769887,596221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 627216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 627216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]