SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313312 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313312 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583241,287179,844220,714680,1033831,397834,931391,977993,165005,121042,476458,357873,376928,170688,920924,510733,368348,48657,827120,439232,928195,717299,956049,751659,248448,681930,1045489,324093,387540,340832,796155,997185,626504,108833,252147,2667,508217,255827,126346,90287,572442,482291,371322,111947,835939,848462,508000,187972,382756,558402,81047,594193,247727,104928,968016,305394,99740,602660,779025,182628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]