SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398081 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398081 [ RunTime:0.002566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418116,31572,446323,237434,722999,27694,227797,111185,834724,536732,527170,809258,299898,957950,832862,286000,261428,721394,399310,634028,209493,442654,127975,838803,131880,392647,126173,630888,121951,108690,377773,919972,358401,61763,864445,712829,1000218,735904,739400,203456,1005254,428020,283254,106691,612542,346723,221585,710043,985605,337973,36486,589149,373695,553358,274398,754177,206348,231242,574774,822528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001759s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]