SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 609411 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 609411 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185728,788136,728523,492743,587500,341948,912750,652716,168183,288257,803762,342468,554576,756,820944,63621,1036120,653717,416083,525543,494535,241948,634049,123793,283642,498013,928472,197875,442392,286541,600299,330445,1007175,964800,210327,1000436,724728,199993,731756,471121,354356,499572,462745,571054,90866,622259,993275,856715,60231,1019851,94173,163501,926579,350063,878983,611879,1039653,221728,1403,121143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 609411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 609411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000933s ]