SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003451s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422081 LIMIT 1 [ RunTime:0.001480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422081 [ RunTime:0.003925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856303,816206,1009336,106893,726596,158660,312706,133408,821422,41693,873041,183103,803437,474657,691272,460696,838484,239206,212,142954,945158,58051,195584,448051,956426,615782,493212,921669,265338,182167,6172,971047,492676,941032,120735,146524,150982,105962,1033748,377141,72667,416926,475966,641642,111501,42687,499241,879199,891931,445364,649533,867429,890777,939318,659959,90953,602539,563255,572881,189846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]