SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002926s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004443 LIMIT 1 [ RunTime:0.001687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004443 [ RunTime:0.002513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557837,835964,421956,340908,320928,878404,581451,897287,346599,968967,201595,275688,309574,754845,212861,902770,101344,1019859,575900,249198,34085,385411,675608,405480,672818,813404,1021188,375892,273245,425099,1033619,742967,671255,412932,588453,700612,812904,851957,524507,326109,464868,636962,757103,934448,728376,491550,214858,458366,975867,864510,120493,945721,759906,550405,723082,630357,986091,413591,544586,530141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]