SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381138 LIMIT 1 [ RunTime:0.000567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381138 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47951,564530,131192,921215,463868,768111,795995,440294,863187,400032,1035640,751945,402323,342493,145021,844228,281138,1022849,1011854,868300,675931,164942,234718,338012,1000665,459538,691190,228626,25962,334530,1015794,62086,406486,438438,838542,833278,37276,438193,356227,1022817,293772,466038,797602,889606,342778,341696,62591,1027532,92851,3101,439295,768393,173789,327400,462690,588845,1015015,15948,1019974,320457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002132s ]