SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047008 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047008 [ RunTime:0.002037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042506,859960,134808,656212,675509,83840,198711,816772,248154,780980,206626,414208,387063,417000,372848,830070,981611,653529,693086,695617,226687,699461,891811,211897,623170,32246,943683,230795,543846,608995,1022552,239742,429448,248727,789859,1031483,778252,535245,358353,949123,828027,882204,172602,539657,628233,477013,246405,287110,46917,696030,218974,426177,238953,677231,487981,63166,33110,395413,29549,238971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]