SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413205 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413205 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84758,539258,273827,756530,984511,266662,295963,337678,445104,319052,404312,103767,869389,286486,85089,197305,831057,705858,313661,310481,565155,969954,542668,786492,632218,957407,1030444,600002,66649,1030729,294657,413333,491488,334640,119850,305126,200534,555105,934001,486008,770900,926870,354660,236571,921908,471452,172172,19874,784537,846402,374476,390030,500795,932306,886217,302096,405368,578574,349573,53479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]