SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541235 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541235 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300924,545316,1017845,287157,303454,962256,476902,871089,277133,63455,489849,335429,827238,419789,606090,357793,888269,904830,644615,710695,988474,209079,413512,1007413,332923,504584,693801,421771,203677,680011,898988,386824,131034,666842,45720,1005435,141142,250856,183061,904401,369975,350327,595954,1029770,283446,1006378,573007,731421,81592,525755,1011969,394824,398566,785976,164750,231441,723433,184218,943876,73832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541235 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541235 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]