SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802728 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802728 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (760595,191421,376129,735311,1024391,372110,1029946,355983,256331,245976,810557,331314,142634,372968,574121,358496,799440,952245,680431,540607,291319,522183,92023,248555,739038,12432,999019,1043720,406177,670757,1043357,997442,51592,195055,297226,682489,53850,442067,247663,980406,18922,494044,310401,659375,710217,982138,674116,326660,502330,402666,489328,821177,78853,133754,990535,819940,985788,190613,970323,656417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001463s ]