SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022508 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022508 [ RunTime:0.002734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436407,527833,897931,44590,79543,586834,146621,187834,498953,1006962,518671,942541,187494,548867,609753,835842,796195,657035,278971,85567,553188,701281,181196,344122,302967,250163,895076,583993,237992,785712,434637,557334,212696,366495,871358,672025,144052,1040787,911285,816736,593694,856583,58026,612216,434795,52158,925855,132120,894439,812103,571659,793264,304574,347166,469521,213993,498896,577858,256985,575126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]