SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538014 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538014 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745693,217367,234394,798724,457194,331325,166032,799694,503535,655482,137675,803246,971826,390,807873,387394,235787,430468,353778,268701,384160,1007775,333767,107526,1043053,936721,886066,867380,245247,1012682,474588,328508,319131,785592,664428,91216,717567,316320,322241,546135,759086,414184,441969,46549,720910,31138,141995,762258,220053,724858,294955,383277,776604,594965,294923,55572,644979,419293,773798,158603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]