SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508770 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508770 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717999,795473,989203,972961,450588,550106,585652,81253,762213,173230,92910,1029117,434746,333368,1042047,344448,605816,773113,670615,519350,589884,164574,17540,543947,486647,754227,43450,390722,211932,938922,1017373,932732,521969,1000558,357405,186800,27150,579857,869649,1026651,129779,59054,304804,117454,726987,733214,572908,319847,74421,345362,433200,16821,281806,43699,265299,255284,142622,131597,1018869,81564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]