SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438561 LIMIT 1 [ RunTime:0.002398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438561 [ RunTime:0.002566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516738,727500,166722,386903,793352,983677,44112,538599,524820,640299,280425,359211,273157,246112,875389,520799,987221,711117,224042,524158,767801,970258,412690,780716,1019946,214600,270872,924363,7383,815284,147443,20750,453708,802666,245075,1013555,318860,704567,10758,667304,695800,184017,222993,88368,556446,310979,128766,983107,263616,1029246,851266,685239,657623,247347,386882,689586,478197,507673,834014,423462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000752s ]