SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001640s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430407 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430407 [ RunTime:0.002699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200524,955604,352857,72663,971256,146805,36057,734622,541920,495738,324840,739997,291836,683876,862081,159809,917718,866203,235787,778206,159383,950202,248032,497635,726597,369825,761183,82435,636147,120657,635128,194048,865986,893138,141602,846731,952590,796098,877618,544591,153263,686967,722952,784054,404683,786818,679740,93436,773669,142304,762814,114493,278,760356,203173,723828,463063,726485,1004724,137616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]