SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421805 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421805 [ RunTime:0.002116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029246,749506,971255,453534,500982,832476,903505,97445,114107,959972,791572,305702,983830,738220,753065,450099,294209,112997,190220,160601,725705,106030,613338,105889,18283,199135,177606,533018,189356,1020010,1012966,620700,896317,62269,543032,520808,232806,223532,842841,409417,375606,751875,456452,118314,205284,725250,647532,110040,590484,325290,581578,129260,1044895,210439,811846,534430,571448,746492,1042166,407780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]