SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319397 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319397 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657959,482674,957386,394791,685957,265240,942742,4921,187538,1042163,838980,581920,337470,17682,66757,537358,650610,750280,92635,1022763,705166,445228,496690,900972,1039966,56940,457606,926978,1023526,649149,141738,102601,545280,787684,214702,681414,369660,300921,452361,956951,33819,314325,365109,369199,140242,156751,998742,84878,732451,671679,625774,717418,768190,234516,825182,896300,862107,823733,330285,198738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319397 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319397 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]