SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503683 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503683 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496822,63219,983289,638822,58981,298230,134082,940461,205317,448167,568467,819161,349558,554139,1006483,832580,1047138,132328,1032616,847799,1021953,844323,702335,134390,161496,983745,4154,801603,203220,870531,1020107,998208,830079,543265,804873,932462,190999,995386,94202,985129,785373,375409,150746,123467,375590,505433,417610,801971,395223,608678,84060,218689,305451,902881,699937,62853,288337,875212,863174,965302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]