SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001960s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014420 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014420 [ RunTime:0.003052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150047,760315,71863,983983,324350,263090,1034385,330309,510001,131180,751328,183862,243542,1045132,375985,1034876,844450,986381,332733,465217,825951,125978,1042205,726038,635463,837162,762922,34917,219954,89964,42705,38338,536982,657572,991143,1038876,379534,268190,42557,786715,353971,992960,696218,827051,122052,326214,109010,97635,601357,94722,1018991,11230,415855,947322,361098,309882,229217,507229,853567,185301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001614s ]