SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316178 LIMIT 1 [ RunTime:0.000495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316178 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802572,104955,90158,340657,944323,896713,501548,1026907,15960,482811,860481,464753,552089,220840,1048554,935134,422776,112082,239375,229033,287424,26235,120466,508167,1037476,67505,898566,1030219,753345,864332,563451,1003240,1023154,235651,490475,264628,604160,780081,527151,526492,406268,86487,493126,1001949,869042,783556,750531,564506,841816,611543,585008,360851,36239,287978,663971,650537,272843,293118,349028,956703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]