SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499496 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499496 [ RunTime:0.002127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197951,894462,997717,209070,450058,54864,140877,179129,16842,860434,307267,974543,864033,401918,141783,906042,857034,840486,440846,395556,812903,824784,664997,357400,508421,760754,515967,840806,158981,796634,887032,907843,159437,1015997,76060,145797,964208,717700,646612,579089,775194,530847,606828,479914,383202,1034006,795393,514949,575683,1032232,461770,367392,184518,791235,707597,401306,803574,30233,421041,255884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]