SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 246306 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 246306 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447425,221134,502563,472504,236892,226336,195842,547094,1024533,719973,1022866,894677,932045,756438,355108,1045432,266428,871335,454154,516618,1010140,620488,908222,279601,508873,984863,797512,782780,1004235,656059,387917,498128,219946,1024503,296748,928854,798628,622911,752119,127471,715361,800028,885920,343123,704625,237475,419782,465806,16575,222895,782948,54203,368106,388237,529187,729919,917671,352602,112637,269419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 246306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 246306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001215s ]