SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021330 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021330 [ RunTime:0.003088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524816,842566,859054,899999,489897,1035693,282968,1022232,592759,569480,110125,1009533,617129,695039,244911,399085,333713,845410,758650,522788,423765,464379,969860,208199,460895,650359,419540,791987,328819,885681,675416,226424,595027,914247,853305,645842,572571,1026688,965125,956799,1031510,203115,439981,658001,574310,515923,649236,19568,430012,910242,351802,286077,377580,779214,318921,805144,61659,953794,726096,681102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001228s ]