SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001981s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330438 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330438 [ RunTime:0.002803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320638,444818,483706,15225,712565,475711,763512,877692,907228,339807,18484,651772,869143,103537,718335,787058,121653,605252,942549,874166,835213,3692,85038,75046,246068,623592,233443,130518,971148,598163,669606,605182,91259,250627,888000,287086,894412,98289,803463,416839,577456,689917,305524,371282,94254,574426,1013935,259293,773742,185945,536330,225845,193526,195447,130781,1036438,481300,523614,235500,1028587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002800s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000847s ]