SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401162 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401162 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013747,665850,563150,815807,515303,189496,265611,156650,717677,141387,251490,414480,229713,767977,10185,512901,430540,901753,449728,298145,157712,348382,806728,487981,851766,275355,595596,269928,889380,955799,878310,456841,1026819,318285,371481,586460,143530,114162,447338,427066,376878,1009398,2243,390849,520237,549717,201048,310412,289392,540526,574761,118950,786262,778485,894225,737320,797811,329590,557741,408021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401162 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401162 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]