SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450194 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450194 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358354,813969,130762,471376,259757,51263,273190,473636,908092,438736,342588,115592,380898,674440,582144,796394,821107,736689,269024,649858,721221,775887,635130,472228,150136,613145,547078,804853,526952,293832,283775,631667,851509,884960,73265,1010882,946979,131900,1010276,131647,546966,701779,634135,676633,369066,363189,600211,691376,37974,534055,815983,664991,845499,559949,988001,1001844,264610,418527,914580,666688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]