SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032200 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032200 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952066,500478,21442,232355,256861,906760,508989,697026,56843,186098,468239,410656,943936,597732,701123,490569,162917,632897,245483,981511,366184,108470,922549,379895,437798,339720,252073,207009,447061,46176,745824,957132,183440,641299,726575,151689,710782,864818,765944,883976,509482,554378,386573,107862,676527,778217,504188,501724,588529,962742,679938,580804,558090,44452,925601,311199,634328,153938,119938,982920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]