SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398185 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398185 [ RunTime:0.005610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510300,342964,956097,338011,802814,410780,897547,121778,29373,89518,176689,663738,216655,130658,643962,377916,908401,415804,111122,145134,236855,811921,851621,393662,701258,612165,289365,32484,458034,298862,73148,224853,97666,891210,699994,906348,1018476,934535,961762,222249,200599,481783,614976,699430,342033,845547,597140,689973,85676,761155,652813,663199,71662,973443,648613,24763,1015752,1013778,203783,805954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]