SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310077 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310077 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010622,346243,800613,166460,512114,1048241,920803,935202,724310,207695,348398,506240,242470,859899,782555,254745,1004904,436392,1001688,985527,866230,754307,177907,709829,948083,175374,779215,192245,870739,712523,595758,67841,134498,331404,898914,200043,892370,834805,309,915211,622894,828806,378342,439382,341805,776418,159392,897643,529039,360138,898790,516216,580250,1041463,442755,882197,721477,679384,315772,731570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310077 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310077 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]