SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538315 LIMIT 1 [ RunTime:0.000829s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538315 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451205,423609,920140,857492,346257,252188,770978,1034708,141700,409198,437011,381918,608296,926398,367916,531324,958406,324403,601230,30676,631628,129358,300087,91108,204422,179740,642190,592032,475144,815922,1038995,91268,160083,776560,105563,151542,412419,649663,11363,469123,44272,763667,287974,753278,972867,760858,49701,368091,387018,472958,693159,393435,27602,877189,52007,1007058,349367,564849,195094,915469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003722s ]