SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840283 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840283 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212689,451570,1046710,421496,827475,510081,243018,776393,748520,48692,939718,459939,591902,909717,186284,617710,689977,849073,706992,240538,732635,54961,18138,104597,957149,484665,669225,731529,737355,1023927,755125,596152,388018,260661,554418,141531,182559,691183,479449,964548,160399,239086,229302,473454,328347,642654,766208,226858,342651,334859,49600,772140,335933,59566,28922,492783,324221,771736,745291,1040753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]