SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305481 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305481 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713384,981855,324278,388670,885996,636373,704171,395827,903641,467673,405273,995247,603,133053,983686,209081,806755,90656,1003602,20903,384893,990985,480328,1018555,127291,41872,701954,686400,671728,286739,633196,927677,636692,412664,620577,575927,334540,933704,72332,77853,1027489,929179,627825,851327,624709,605217,562037,19154,576009,952430,230032,113768,915667,395340,1038661,253000,367520,99535,595277,1024636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]