SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510908 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510908 [ RunTime:0.001455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286394,772502,208316,420197,731696,505792,704889,620373,859159,373884,773327,686531,308009,829004,966335,148451,351558,987882,53885,291104,956816,1043782,604020,973424,156618,688848,135176,249402,721044,708948,941459,823030,235981,919255,519722,422528,893944,973736,784585,217806,943638,474882,26958,135996,900852,789359,83662,628652,386648,354393,46382,477114,223201,944613,71206,322571,784785,926110,378580,735589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]