SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199826 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199826 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97685,134070,253462,1021020,336130,1017052,967577,203371,238018,350146,797864,842428,769376,40520,971384,301243,804600,944644,868485,416226,383748,538225,932451,1014003,1048916,10183,732233,747334,153929,523221,90287,498103,344383,1008134,448509,404295,645612,591048,573826,426057,1014680,216337,361393,1035352,770139,788557,647288,584631,648525,799641,361240,633686,217704,136017,470311,777909,1047333,727959,20811,387903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]