SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319559 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319559 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767654,699858,162024,994486,515172,372843,707227,250716,376532,995836,69956,118333,800792,763592,444521,703600,222929,533640,114567,1034766,293267,773068,405542,1045282,284422,553384,281435,673859,944260,391680,1048366,253700,365326,136219,126620,920721,911032,1020271,1044068,843141,681753,579490,942247,628340,652275,39363,514844,609947,270449,399125,807896,432481,301700,976298,504570,1032791,818538,368783,1041258,1005002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319559 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319559 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]