SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503335 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503335 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (966676,801017,192010,762491,840429,988508,384179,589896,44614,152914,168180,24719,291172,32528,714411,906628,259366,555380,6181,503731,510491,1013642,496375,804703,410221,50774,151923,387171,7029,886282,120683,154630,852813,899897,294327,888332,3324,548162,232338,186527,763453,403638,295164,794253,585711,412182,671427,1015177,436653,953756,637124,925103,77325,97779,816638,36791,1019691,426396,450428,758683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]