SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328582 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328582 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504847,309689,125877,334625,767253,290432,49302,422176,830719,535579,64819,865091,555742,808294,405708,1048363,727751,210523,800280,84682,968799,638392,976594,342145,961640,696324,220025,351929,912124,688602,902900,1036384,668534,7840,325703,713889,407072,8067,302826,695194,77598,642857,713234,840932,927594,1018037,376534,260460,1018007,176916,697668,624613,506741,254834,755754,836617,1027936,704077,110846,138878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]