SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008028 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008028 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93479,143506,161208,568841,109927,839823,379955,902635,151955,188108,679880,147806,288309,470718,413328,315964,859233,138767,819956,995334,322576,166999,510069,487322,201006,51060,591543,731909,716393,331686,598288,581169,651504,259326,234011,656945,638219,537665,677914,596013,712939,652554,658896,620892,399668,551717,118908,788596,789877,222504,402190,760616,1034016,118388,396984,568832,703196,107518,680455,808790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]